package com.tjetc.dao;

import com.tjetc.domian.Resident;
import com.tjetc.vo.Result;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ResidentMapper {
    int deleteByPrimaryKey(Integer residentid);

    int insert(Resident record);

    int insertSelective(Resident record);

    Resident selectByPrimaryKey(Integer residentid);

    int updateByPrimaryKeySelective(Resident record);

    int updateByPrimaryKey(Resident record);

    @Select("select * from resident")
    List<Resident> select();

    @Select("select ApartmentID from resident where ResidentID=#{residentId} ")
    int getApartmentId(int residentId);

    int getApartmentIdByname(String name);


}